#Installation step
!pip install pandas-profiling
#or
#import sys
#!{sys.executable} -m pip install pandas-profiling
Requirement already satisfied: pandas-profiling in c:\users\syeda\anaconda3\lib\site-packages (3.0.0) Requirement already satisfied: PyYAML>=5.0.0 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (5.4.1) Requirement already satisfied: pydantic>=1.8.1 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (1.8.2) Requirement already satisfied: scipy>=1.4.1 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (1.6.2) Requirement already satisfied: matplotlib>=3.2.0 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (3.3.4) Requirement already satisfied: phik>=0.11.1 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (0.12.0) Requirement already satisfied: visions[type_image_path]==0.7.1 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (0.7.1) Requirement already satisfied: numpy>=1.16.0 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (1.20.1) Requirement already satisfied: tqdm>=4.48.2 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (4.59.0) Requirement already satisfied: seaborn>=0.10.1 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (0.11.1) Requirement already satisfied: requests>=2.24.0 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (2.25.1) Requirement already satisfied: jinja2>=2.11.1 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (2.11.3) Requirement already satisfied: tangled-up-in-unicode==0.1.0 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (0.1.0) Requirement already satisfied: missingno>=0.4.2 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (0.5.0) Requirement already satisfied: htmlmin>=0.1.12 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (0.1.12) Requirement already satisfied: joblib in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (1.0.1) Requirement already satisfied: pandas!=1.0.0,!=1.0.1,!=1.0.2,!=1.1.0,>=0.25.3 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (1.2.4) Requirement already satisfied: bottleneck in c:\users\syeda\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.1->pandas-profiling) (1.3.2) Requirement already satisfied: attrs>=19.3.0 in c:\users\syeda\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.1->pandas-profiling) (20.3.0) Requirement already satisfied: multimethod==1.4 in c:\users\syeda\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.1->pandas-profiling) (1.4) Requirement already satisfied: networkx>=2.4 in c:\users\syeda\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.1->pandas-profiling) (2.5) Requirement already satisfied: Pillow in c:\users\syeda\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.1->pandas-profiling) (8.2.0) Requirement already satisfied: imagehash in c:\users\syeda\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.1->pandas-profiling) (4.2.1) Requirement already satisfied: MarkupSafe>=0.23 in c:\users\syeda\anaconda3\lib\site-packages (from jinja2>=2.11.1->pandas-profiling) (1.1.1) Requirement already satisfied: cycler>=0.10 in c:\users\syeda\anaconda3\lib\site-packages (from matplotlib>=3.2.0->pandas-profiling) (0.10.0) Requirement already satisfied: python-dateutil>=2.1 in c:\users\syeda\anaconda3\lib\site-packages (from matplotlib>=3.2.0->pandas-profiling) (2.8.1) Requirement already satisfied: pyparsing!=2.0.4,!=2.1.2,!=2.1.6,>=2.0.3 in c:\users\syeda\anaconda3\lib\site-packages (from matplotlib>=3.2.0->pandas-profiling) (2.4.7) Requirement already satisfied: kiwisolver>=1.0.1 in c:\users\syeda\anaconda3\lib\site-packages (from matplotlib>=3.2.0->pandas-profiling) (1.3.1) Requirement already satisfied: six in c:\users\syeda\anaconda3\lib\site-packages (from cycler>=0.10->matplotlib>=3.2.0->pandas-profiling) (1.15.0) Requirement already satisfied: decorator>=4.3.0 in c:\users\syeda\anaconda3\lib\site-packages (from networkx>=2.4->visions[type_image_path]==0.7.1->pandas-profiling) (5.0.6) Requirement already satisfied: pytz>=2017.3 in c:\users\syeda\anaconda3\lib\site-packages (from pandas!=1.0.0,!=1.0.1,!=1.0.2,!=1.1.0,>=0.25.3->pandas-profiling) (2021.1) Requirement already satisfied: typing-extensions>=3.7.4.3 in c:\users\syeda\anaconda3\lib\site-packages (from pydantic>=1.8.1->pandas-profiling) (3.7.4.3) Requirement already satisfied: urllib3<1.27,>=1.21.1 in c:\users\syeda\anaconda3\lib\site-packages (from requests>=2.24.0->pandas-profiling) (1.26.4) Requirement already satisfied: chardet<5,>=3.0.2 in c:\users\syeda\anaconda3\lib\site-packages (from requests>=2.24.0->pandas-profiling) (4.0.0) Requirement already satisfied: certifi>=2017.4.17 in c:\users\syeda\anaconda3\lib\site-packages (from requests>=2.24.0->pandas-profiling) (2020.12.5) Requirement already satisfied: idna<3,>=2.5 in c:\users\syeda\anaconda3\lib\site-packages (from requests>=2.24.0->pandas-profiling) (2.10) Requirement already satisfied: PyWavelets in c:\users\syeda\anaconda3\lib\site-packages (from imagehash->visions[type_image_path]==0.7.1->pandas-profiling) (1.1.1)
import pandas_profiling
import pandas as pd
df = pd.read_csv('C:/Users/syeda/Downloads/match_data.csv')
df.head()
| id | season | city | date | team1 | team2 | toss_winner | toss_decision | winner | eliminator | ... | overs | player_of_match | venue | umpire1 | umpire2 | umpire3 | first_bat_team | first_bowl_team | first_bat_score | second_bat_score | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 419164 | 2010 | Mumbai | 2010-04-24 | Royal Challengers Bangalore | Deccan Chargers | Deccan Chargers | bat | Royal Challengers Bangalore | NaN | ... | 20 | A Kumble | Dr DY Patil Sports Academy | RE Koertzen | SJA Taufel | NaN | Deccan Chargers | Royal Challengers Bangalore | 82.0 | 86.0 |
| 1 | 419131 | 2010 | Delhi | 2010-03-29 | Delhi Daredevils | Kolkata Knight Riders | Delhi Daredevils | bat | Delhi Daredevils | NaN | ... | 20 | DA Warner | Feroz Shah Kotla | SS Hazare | SJA Taufel | NaN | Delhi Daredevils | Kolkata Knight Riders | 177.0 | 137.0 |
| 2 | 336021 | 2008 | Mumbai | 2008-05-16 | Mumbai Indians | Kolkata Knight Riders | Mumbai Indians | field | Mumbai Indians | NaN | ... | 20 | SM Pollock | Wankhede Stadium | BR Doctrove | DJ Harper | NaN | Kolkata Knight Riders | Mumbai Indians | 67.0 | 68.0 |
| 3 | 980931 | 2016 | Pune | 2016-04-22 | Rising Pune Supergiants | Royal Challengers Bangalore | Rising Pune Supergiants | field | Royal Challengers Bangalore | NaN | ... | 20 | AB de Villiers | Maharashtra Cricket Association Stadium | CB Gaffaney | VK Sharma | NaN | Royal Challengers Bangalore | Rising Pune Supergiants | 185.0 | 172.0 |
| 4 | 419163 | 2010 | Mumbai | 2010-04-22 | Chennai Super Kings | Deccan Chargers | Chennai Super Kings | bat | Chennai Super Kings | NaN | ... | 20 | DE Bollinger | Dr DY Patil Sports Academy | BR Doctrove | RB Tiffin | NaN | Chennai Super Kings | Deccan Chargers | 142.0 | 104.0 |
5 rows × 24 columns
#Getting the pandas profiling report
pandas_profiling.ProfileReport(df)